Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 1928270 |
| Missing cells | 1254288 |
| Missing cells (%) | 5.4% |
| Duplicate rows | 1835 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 255.7 MiB |
| Average record size in memory | 139.1 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 3 |
RND has constant value "0" | Constant |
| Dataset has 1835 (0.1%) duplicate rows | Duplicates |
FUEL_RATE is highly overall correlated with PAYLOAD | High correlation |
PAYLOAD is highly overall correlated with FUEL_RATE | High correlation |
GPSELEVATION has 140290 (7.3%) missing values | Missing |
FUEL_RATE has 777687 (40.3%) missing values | Missing |
PAYLOAD has 324687 (16.8%) missing values | Missing |
GPSNORTHING is highly skewed (γ1 = -170.5008896) | Skewed |
GPSEASTING is highly skewed (γ1 = 92.30052561) | Skewed |
FUEL_RATE is highly skewed (γ1 = 110.4394249) | Skewed |
PAYLOAD has 1321626 (68.5%) zeros | Zeros |
SHOVEL_ID has 59787 (3.1%) zeros | Zeros |
DUMP_ID has 57984 (3.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-01-07 02:50:40.360592 |
|---|---|
| Analysis finished | 2023-01-07 02:52:58.860116 |
| Duration | 2 minutes and 18.5 seconds |
| Software version | pandas-profiling vv3.6.2 |
| Download configuration | config.json |
TIMESTAMP
Real number (ℝ)
| Distinct | 344331 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6492877 × 1012 |
| Minimum | 1.6489441 × 1012 |
|---|---|
| Maximum | 1.6496352 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 1.6489441 × 1012 |
|---|---|
| 5-th percentile | 1.6489834 × 1012 |
| Q1 | 1.6491168 × 1012 |
| median | 1.6492854 × 1012 |
| Q3 | 1.6494577 × 1012 |
| 95-th percentile | 1.6496008 × 1012 |
| Maximum | 1.6496352 × 1012 |
| Range | 6.91134 × 108 |
| Interquartile range (IQR) | 3.409155 × 108 |
Descriptive statistics
| Standard deviation | 1.9750718 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.00011975302 |
| Kurtosis | -1.1892155 |
| Mean | 1.6492877 × 1012 |
| Median Absolute Deviation (MAD) | 1.70426 × 108 |
| Skewness | 0.029541098 |
| Sum | 3.1802719 × 1018 |
| Variance | 3.9009087 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.649058202 × 1012 | 18 | < 0.1% |
| 1.649515774 × 1012 | 18 | < 0.1% |
| 1.649135874 × 1012 | 17 | < 0.1% |
| 1.649171878 × 1012 | 17 | < 0.1% |
| 1.649030988 × 1012 | 17 | < 0.1% |
| 1.64925337 × 1012 | 17 | < 0.1% |
| 1.649034 × 1012 | 17 | < 0.1% |
| 1.649011012 × 1012 | 17 | < 0.1% |
| 1.649357382 × 1012 | 17 | < 0.1% |
| 1.6495177 × 1012 | 17 | < 0.1% |
| Other values (344321) | 1928098 |
| Value | Count | Frequency (%) |
| 1.648944064 × 1012 | 1 | |
| 1.648944082 × 1012 | 1 | |
| 1.648944098 × 1012 | 2 | |
| 1.648944102 × 1012 | 1 | |
| 1.648944108 × 1012 | 1 | |
| 1.648944116 × 1012 | 1 | |
| 1.64894412 × 1012 | 1 | |
| 1.648944128 × 1012 | 1 | |
| 1.648944132 × 1012 | 1 | |
| 1.64894414 × 1012 | 1 |
| Value | Count | Frequency (%) |
| 1.649635198 × 1012 | 3 | < 0.1% |
| 1.649635196 × 1012 | 6 | |
| 1.649635194 × 1012 | 1 | < 0.1% |
| 1.649635192 × 1012 | 6 | |
| 1.64963519 × 1012 | 5 | |
| 1.649635188 × 1012 | 9 | |
| 1.649635186 × 1012 | 3 | < 0.1% |
| 1.649635184 × 1012 | 5 | |
| 1.649635182 × 1012 | 3 | < 0.1% |
| 1.64963518 × 1012 | 3 | < 0.1% |
GPSNORTHING
Real number (ℝ)
| Distinct | 1919838 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 5812 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55829.379 |
| Minimum | -5978350 |
|---|---|
| Maximum | 61239.654 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 78 |
| Negative (%) | < 0.1% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | -5978350 |
|---|---|
| 5-th percentile | 52937.355 |
| Q1 | 55195.612 |
| median | 56019.237 |
| Q3 | 56975.25 |
| 95-th percentile | 59714.298 |
| Maximum | 61239.654 |
| Range | 6039589.7 |
| Interquartile range (IQR) | 1779.6371 |
Descriptive statistics
| Standard deviation | 33472.358 |
|---|---|
| Coefficient of variation (CV) | 0.59954738 |
| Kurtosis | 29917.148 |
| Mean | 55829.379 |
| Median Absolute Deviation (MAD) | 903.25452 |
| Skewness | -170.50089 |
| Sum | 1.0732964 × 1011 |
| Variance | 1.1203987 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5978350 | 53 | < 0.1% |
| 53282.36354 | 3 | < 0.1% |
| 52601.5525 | 3 | < 0.1% |
| 52962.29498 | 3 | < 0.1% |
| 52605.32465 | 3 | < 0.1% |
| 53121.5436 | 3 | < 0.1% |
| 54540.6416 | 2 | < 0.1% |
| 52597.50584 | 2 | < 0.1% |
| 55214.72796 | 2 | < 0.1% |
| 55760.79237 | 2 | < 0.1% |
| Other values (1919828) | 1922382 | |
| (Missing) | 5812 | 0.3% |
| Value | Count | Frequency (%) |
| -5978350 | 53 | |
| -2962544.489 | 1 | < 0.1% |
| -2961017.207 | 1 | < 0.1% |
| -2961015.688 | 1 | < 0.1% |
| -2961007.422 | 1 | < 0.1% |
| -2961001.963 | 1 | < 0.1% |
| -2960996.355 | 1 | < 0.1% |
| -2960992.46 | 1 | < 0.1% |
| -2960987.422 | 1 | < 0.1% |
| -2960986.554 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 61239.65421 | 1 | |
| 61235.91067 | 1 | |
| 61216.35964 | 1 | |
| 61188.98726 | 1 | |
| 61188.61279 | 1 | |
| 61187.15287 | 1 | |
| 61185.37001 | 1 | |
| 61184.25664 | 1 | |
| 61184.16772 | 1 | |
| 61178.07432 | 1 |
GPSEASTING
Real number (ℝ)
| Distinct | 1919910 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 5812 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 227463.25 |
| Minimum | 222469.51 |
|---|---|
| Maximum | 671590.38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 222469.51 |
|---|---|
| 5-th percentile | 223765.92 |
| Q1 | 227413.32 |
| median | 228135.24 |
| Q3 | 228640.15 |
| 95-th percentile | 229200.33 |
| Maximum | 671590.38 |
| Range | 449120.87 |
| Interquartile range (IQR) | 1226.8313 |
Descriptive statistics
| Standard deviation | 3020.5209 |
|---|---|
| Coefficient of variation (CV) | 0.01327916 |
| Kurtosis | 13239.328 |
| Mean | 227463.25 |
| Median Absolute Deviation (MAD) | 622.60358 |
| Skewness | 92.300526 |
| Sum | 4.3728855 × 1011 |
| Variance | 9123546.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 671590.3795 | 53 | < 0.1% |
| 227576.0002 | 3 | < 0.1% |
| 227661.694 | 3 | < 0.1% |
| 227660.8086 | 3 | < 0.1% |
| 224534.7525 | 2 | < 0.1% |
| 227408.2111 | 2 | < 0.1% |
| 227536.8049 | 2 | < 0.1% |
| 228497.5337 | 2 | < 0.1% |
| 224737.8254 | 2 | < 0.1% |
| 227408.9431 | 2 | < 0.1% |
| Other values (1919900) | 1922384 | |
| (Missing) | 5812 | 0.3% |
| Value | Count | Frequency (%) |
| 222469.5098 | 1 | |
| 222470.6495 | 1 | |
| 222471.5773 | 1 | |
| 222471.9405 | 1 | |
| 222472.6591 | 1 | |
| 222472.6663 | 1 | |
| 222472.8266 | 1 | |
| 222472.9764 | 1 | |
| 222473.0126 | 1 | |
| 222473.0149 | 1 |
| Value | Count | Frequency (%) |
| 671590.3795 | 53 | |
| 449690.6376 | 1 | < 0.1% |
| 449670.9756 | 1 | < 0.1% |
| 449620.7566 | 1 | < 0.1% |
| 449618.6994 | 1 | < 0.1% |
| 449603.0126 | 1 | < 0.1% |
| 449602.2112 | 1 | < 0.1% |
| 449600.0127 | 1 | < 0.1% |
| 449593.6226 | 1 | < 0.1% |
| 449588.1352 | 1 | < 0.1% |
GPSELEVATION
Real number (ℝ)
| Distinct | 15828 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 140290 |
| Missing (%) | 7.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 206.18528 |
| Minimum | -1218 |
|---|---|
| Maximum | 682.9732 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 435 |
| Negative (%) | < 0.1% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | -1218 |
|---|---|
| 5-th percentile | 92.0808 |
| Q1 | 135.807 |
| median | 199.9144 |
| Q3 | 246.036 |
| 95-th percentile | 364.5474 |
| Maximum | 682.9732 |
| Range | 1900.9732 |
| Interquartile range (IQR) | 110.229 |
Descriptive statistics
| Standard deviation | 87.116756 |
|---|---|
| Coefficient of variation (CV) | 0.42251685 |
| Kurtosis | 1.3549084 |
| Mean | 206.18528 |
| Median Absolute Deviation (MAD) | 60.291 |
| Skewness | 0.32506632 |
| Sum | 3.6865516 × 108 |
| Variance | 7589.3292 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 103.124 | 1187 | 0.1% |
| 103.2052 | 1172 | 0.1% |
| 102.718 | 1152 | 0.1% |
| 103.4488 | 1137 | 0.1% |
| 102.9616 | 1135 | 0.1% |
| 102.5556 | 1134 | 0.1% |
| 102.6368 | 1130 | 0.1% |
| 103.53 | 1129 | 0.1% |
| 103.3676 | 1128 | 0.1% |
| 102.4744 | 1113 | 0.1% |
| Other values (15818) | 1776563 | |
| (Missing) | 140290 | 7.3% |
| Value | Count | Frequency (%) |
| -1218 | 51 | |
| -711.7992 | 1 | < 0.1% |
| -665.7994 | 1 | < 0.1% |
| -663.8912 | 1 | < 0.1% |
| -659.8312 | 1 | < 0.1% |
| -640.1402 | 1 | < 0.1% |
| -634.0502 | 1 | < 0.1% |
| -606.4016 | 1 | < 0.1% |
| -605.143 | 1 | < 0.1% |
| -578.6718 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 682.9732 | 1 | |
| 667.87 | 1 | |
| 666.5708 | 1 | |
| 616.7546 | 1 | |
| 613.6284 | 1 | |
| 527.2722 | 1 | |
| 520.7356 | 1 | |
| 502.9528 | 1 | |
| 494.1426 | 1 | |
| 493.29 | 1 |
FUEL_RATE
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 28096 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 777687 |
| Missing (%) | 40.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 200.01969 |
| Minimum | 196 |
|---|---|
| Maximum | 1506.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 196 |
|---|---|
| 5-th percentile | 196.2975 |
| Q1 | 196.5345 |
| median | 197.4355 |
| Q3 | 204.8695 |
| 95-th percentile | 207.11 |
| Maximum | 1506.7 |
| Range | 1310.7 |
| Interquartile range (IQR) | 8.335 |
Descriptive statistics
| Standard deviation | 9.3396836 |
|---|---|
| Coefficient of variation (CV) | 0.046693822 |
| Kurtosis | 15376.383 |
| Mean | 200.01969 |
| Median Absolute Deviation (MAD) | 1.0845 |
| Skewness | 110.43942 |
| Sum | 2.3013925 × 108 |
| Variance | 87.229691 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 206.239 | 24511 | 1.3% |
| 196 | 4902 | 0.3% |
| 196.476 | 928 | < 0.1% |
| 196.47 | 911 | < 0.1% |
| 206.233 | 897 | < 0.1% |
| 196.474 | 893 | < 0.1% |
| 196.471 | 891 | < 0.1% |
| 196.472 | 891 | < 0.1% |
| 196.468 | 891 | < 0.1% |
| 196.473 | 885 | < 0.1% |
| Other values (28086) | 1113983 | |
| (Missing) | 777687 |
| Value | Count | Frequency (%) |
| 196 | 4902 | |
| 196.0005 | 18 | < 0.1% |
| 196.001 | 77 | < 0.1% |
| 196.0015 | 26 | < 0.1% |
| 196.002 | 95 | < 0.1% |
| 196.0025 | 28 | < 0.1% |
| 196.003 | 86 | < 0.1% |
| 196.0035 | 22 | < 0.1% |
| 196.004 | 98 | < 0.1% |
| 196.0045 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 1506.7 | 46 | |
| 851.4305 | 1 | < 0.1% |
| 851.3505 | 1 | < 0.1% |
| 851.35 | 1 | < 0.1% |
| 260.255 | 1 | < 0.1% |
| 228.1275 | 1 | < 0.1% |
| 215.7585 | 1 | < 0.1% |
| 215.552 | 1 | < 0.1% |
| 215.3425 | 1 | < 0.1% |
| 215.137 | 1 | < 0.1% |
STATUS
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.4 MiB |
| NON_PRODUCTIVE | |
|---|---|
| Hauling | |
| Empty | |
| Truck Loading | |
| Queue At LU | 61360 |
| Other values (4) |
Length
| Max length | 24 |
|---|---|
| Median length | 15 |
| Mean length | 9.5213139 |
| Min length | 5 |
Characters and Unicode
| Total characters | 18359664 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Empty |
|---|---|
| 2nd row | Empty |
| 3rd row | Empty |
| 4th row | Empty |
| 5th row | Empty |
Common Values
| Value | Count | Frequency (%) |
| NON_PRODUCTIVE | 669920 | |
| Hauling | 606644 | |
| Empty | 427149 | |
| Truck Loading | 91686 | 4.8% |
| Queue At LU | 61360 | 3.2% |
| Dumping | 30013 | 1.6% |
| Spot at LU | 21357 | 1.1% |
| Queuing at Dump | 19488 | 1.0% |
| Wenco General Production | 653 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| non_productive | 669920 | |
| hauling | 606644 | |
| empty | 427149 | |
| at | 102205 | 4.6% |
| truck | 91686 | 4.1% |
| loading | 91686 | 4.1% |
| lu | 82717 | 3.7% |
| queue | 61360 | 2.8% |
| dumping | 30013 | 1.3% |
| spot | 21357 | 1.0% |
| Other values (5) | 40935 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1339840 | 7.3% |
| O | 1339840 | 7.3% |
| E | 1097069 | 6.0% |
| u | 910180 | 5.0% |
| T | 761606 | 4.1% |
| U | 752637 | 4.1% |
| n | 749790 | 4.1% |
| i | 748484 | 4.1% |
| g | 747831 | 4.1% |
| a | 739828 | 4.0% |
| Other values (26) | 9172559 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10306584 | |
| Lowercase Letter | 7085758 | |
| Connector Punctuation | 669920 | 3.6% |
| Space Separator | 297402 | 1.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1339840 | |
| O | 1339840 | |
| E | 1097069 | |
| T | 761606 | |
| U | 752637 | |
| D | 719421 | |
| P | 670573 | |
| I | 669920 | |
| V | 669920 | |
| C | 669920 | |
| Other values (8) | 1615838 |
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 910180 | |
| n | 749790 | |
| i | 748484 | |
| g | 747831 | |
| a | 739828 | |
| l | 607297 | |
| t | 551364 | |
| p | 498007 | |
| m | 476650 | |
| y | 427149 | |
| Other values (6) | 629178 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 669920 |
Space Separator
| Value | Count | Frequency (%) |
| 297402 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17392342 | |
| Common | 967322 | 5.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1339840 | 7.7% |
| O | 1339840 | 7.7% |
| E | 1097069 | 6.3% |
| u | 910180 | 5.2% |
| T | 761606 | 4.4% |
| U | 752637 | 4.3% |
| n | 749790 | 4.3% |
| i | 748484 | 4.3% |
| g | 747831 | 4.3% |
| a | 739828 | 4.3% |
| Other values (24) | 8205237 |
Common
| Value | Count | Frequency (%) |
| _ | 669920 | |
| 297402 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18359664 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1339840 | 7.3% |
| O | 1339840 | 7.3% |
| E | 1097069 | 6.0% |
| u | 910180 | 5.0% |
| T | 761606 | 4.1% |
| U | 752637 | 4.1% |
| n | 749790 | 4.1% |
| i | 748484 | 4.1% |
| g | 747831 | 4.1% |
| a | 739828 | 4.0% |
| Other values (26) | 9172559 |
PAYLOAD
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 1344 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 324687 |
| Missing (%) | 16.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.576665 |
| Minimum | 0 |
|---|---|
| Maximum | 634.101 |
| Zeros | 1321626 |
| Zeros (%) | 68.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 311.974 |
| Maximum | 634.101 |
| Range | 634.101 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 104.73515 |
|---|---|
| Coefficient of variation (CV) | 2.2486615 |
| Kurtosis | 2.0900349 |
| Mean | 46.576665 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9441091 |
| Sum | 74689548 |
| Variance | 10969.452 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1321626 | |
| 270.439 | 2213 | 0.1% |
| 262.132 | 2190 | 0.1% |
| 312.897 | 2133 | 0.1% |
| 274.131 | 2060 | 0.1% |
| 315.666 | 2044 | 0.1% |
| 287.053 | 1997 | 0.1% |
| 319.358 | 1996 | 0.1% |
| 263.978 | 1981 | 0.1% |
| 311.974 | 1967 | 0.1% |
| Other values (1334) | 263376 | 13.7% |
| (Missing) | 324687 | 16.8% |
| Value | Count | Frequency (%) |
| 0 | 1321626 | |
| 12.922 | 31 | < 0.1% |
| 16.614 | 19 | < 0.1% |
| 17.537 | 68 | < 0.1% |
| 28.613 | 73 | < 0.1% |
| 30.0898 | 70 | < 0.1% |
| 30.1821 | 43 | < 0.1% |
| 34.151 | 59 | < 0.1% |
| 38.9506 | 62 | < 0.1% |
| 44.0271 | 63 | < 0.1% |
| Value | Count | Frequency (%) |
| 634.101 | 42 | |
| 629.486 | 65 | |
| 503.035 | 66 | |
| 472.576 | 19 | < 0.1% |
| 443.963 | 24 | < 0.1% |
| 435.656 | 31 | |
| 425.503 | 25 | < 0.1% |
| 423.657 | 17 | < 0.1% |
| 422.734 | 55 | |
| 418.119 | 21 | < 0.1% |
TRUCK_ID
Real number (ℝ)
| Distinct | 70 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.589543 |
| Minimum | 0 |
|---|---|
| Maximum | 69 |
| Zeros | 15314 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 17 |
| median | 32 |
| Q3 | 48 |
| 95-th percentile | 61 |
| Maximum | 69 |
| Range | 69 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 18.490044 |
|---|---|
| Coefficient of variation (CV) | 0.56736124 |
| Kurtosis | -1.1522754 |
| Mean | 32.589543 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | -0.0074349166 |
| Sum | 62841438 |
| Variance | 341.88171 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29 | 35335 | 1.8% |
| 7 | 34998 | 1.8% |
| 1 | 34509 | 1.8% |
| 42 | 34365 | 1.8% |
| 46 | 34271 | 1.8% |
| 40 | 34210 | 1.8% |
| 30 | 34122 | 1.8% |
| 26 | 34069 | 1.8% |
| 50 | 34018 | 1.8% |
| 52 | 33795 | 1.8% |
| Other values (60) | 1584578 |
| Value | Count | Frequency (%) |
| 0 | 15314 | |
| 1 | 34509 | |
| 2 | 18077 | |
| 3 | 32448 | |
| 4 | 22344 | |
| 5 | 29628 | |
| 6 | 19329 | |
| 7 | 34998 | |
| 8 | 27674 | |
| 9 | 33251 |
| Value | Count | Frequency (%) |
| 69 | 997 | 0.1% |
| 68 | 3551 | 0.2% |
| 67 | 5472 | 0.3% |
| 66 | 9747 | 0.5% |
| 65 | 12143 | 0.6% |
| 64 | 23629 | |
| 63 | 22932 | |
| 62 | 4656 | 0.2% |
| 61 | 30620 | |
| 60 | 26931 |
TRUCK_TYPE_ID
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.4 MiB |
| 3 | |
|---|---|
| 4 | |
| 1 | |
| 2 | |
| 0 | 28454 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1928270 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1928270 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1928270 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1928270 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 1225307 | |
| 4 | 248601 | 12.9% |
| 1 | 246309 | 12.8% |
| 2 | 179599 | 9.3% |
| 0 | 28454 | 1.5% |
SHOVEL_ID
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.594173 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 59787 |
| Zeros (%) | 3.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.1758507 |
|---|---|
| Coefficient of variation (CV) | 0.60538285 |
| Kurtosis | -1.1306948 |
| Mean | 3.594173 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.22467457 |
| Sum | 6930536 |
| Variance | 4.7343262 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 421705 | |
| 3 | 365153 | |
| 4 | 283043 | |
| 6 | 261306 | |
| 7 | 223372 | |
| 2 | 169937 | |
| 5 | 113950 | 5.9% |
| 0 | 59787 | 3.1% |
| 8 | 30017 | 1.6% |
| Value | Count | Frequency (%) |
| 0 | 59787 | 3.1% |
| 1 | 421705 | |
| 2 | 169937 | |
| 3 | 365153 | |
| 4 | 283043 | |
| 5 | 113950 | 5.9% |
| 6 | 261306 | |
| 7 | 223372 | |
| 8 | 30017 | 1.6% |
| Value | Count | Frequency (%) |
| 8 | 30017 | 1.6% |
| 7 | 223372 | |
| 6 | 261306 | |
| 5 | 113950 | 5.9% |
| 4 | 283043 | |
| 3 | 365153 | |
| 2 | 169937 | |
| 1 | 421705 | |
| 0 | 59787 | 3.1% |
DUMP_ID
Real number (ℝ)
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5224201 |
| Minimum | 0 |
|---|---|
| Maximum | 35 |
| Zeros | 57984 |
| Zeros (%) | 3.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 9 |
| 95-th percentile | 22 |
| Maximum | 35 |
| Range | 35 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 6.5940921 |
|---|---|
| Coefficient of variation (CV) | 1.0109886 |
| Kurtosis | 2.4710866 |
| Mean | 6.5224201 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.5523586 |
| Sum | 12576987 |
| Variance | 43.482051 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 505219 | |
| 9 | 333750 | |
| 3 | 244678 | |
| 2 | 179596 | 9.3% |
| 11 | 116824 | 6.1% |
| 5 | 76375 | 4.0% |
| 7 | 69795 | 3.6% |
| 0 | 57984 | 3.0% |
| 15 | 45769 | 2.4% |
| 6 | 41973 | 2.2% |
| Other values (26) | 256307 |
| Value | Count | Frequency (%) |
| 0 | 57984 | 3.0% |
| 1 | 505219 | |
| 2 | 179596 | 9.3% |
| 3 | 244678 | |
| 4 | 1031 | 0.1% |
| 5 | 76375 | 4.0% |
| 6 | 41973 | 2.2% |
| 7 | 69795 | 3.6% |
| 8 | 7954 | 0.4% |
| 9 | 333750 |
| Value | Count | Frequency (%) |
| 35 | 880 | < 0.1% |
| 34 | 1993 | 0.1% |
| 33 | 279 | < 0.1% |
| 32 | 12472 | |
| 31 | 1092 | 0.1% |
| 30 | 199 | < 0.1% |
| 29 | 6624 | 0.3% |
| 28 | 9021 | |
| 27 | 130 | < 0.1% |
| 26 | 20532 |
RND
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.4 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1928270 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1928270 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 1928270 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1928270 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1928270 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1928270 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1928270 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1928270 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1928270 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1928270 |
| TIMESTAMP | GPSNORTHING | GPSEASTING | GPSELEVATION | FUEL_RATE | PAYLOAD | TRUCK_ID | SHOVEL_ID | DUMP_ID | STATUS | TRUCK_TYPE_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TIMESTAMP | 1.000 | -0.032 | 0.037 | -0.045 | 0.027 | -0.062 | 0.098 | 0.112 | 0.048 | 0.022 | 0.040 |
| GPSNORTHING | -0.032 | 1.000 | 0.319 | -0.125 | 0.017 | -0.133 | -0.075 | 0.006 | 0.379 | 0.004 | 0.001 |
| GPSEASTING | 0.037 | 0.319 | 1.000 | -0.443 | -0.026 | 0.047 | -0.009 | 0.111 | 0.158 | 0.004 | 0.001 |
| GPSELEVATION | -0.045 | -0.125 | -0.443 | 1.000 | 0.088 | -0.040 | -0.024 | -0.128 | -0.093 | 0.113 | 0.123 |
| FUEL_RATE | 0.027 | 0.017 | -0.026 | 0.088 | 1.000 | 0.587 | -0.011 | -0.024 | -0.003 | 0.008 | 0.002 |
| PAYLOAD | -0.062 | -0.133 | 0.047 | -0.040 | 0.587 | 1.000 | 0.042 | -0.182 | -0.059 | 0.353 | 0.160 |
| TRUCK_ID | 0.098 | -0.075 | -0.009 | -0.024 | -0.011 | 0.042 | 1.000 | -0.060 | -0.009 | 0.029 | 0.334 |
| SHOVEL_ID | 0.112 | 0.006 | 0.111 | -0.128 | -0.024 | -0.182 | -0.060 | 1.000 | 0.247 | 0.053 | 0.386 |
| DUMP_ID | 0.048 | 0.379 | 0.158 | -0.093 | -0.003 | -0.059 | -0.009 | 0.247 | 1.000 | 0.032 | 0.180 |
| STATUS | 0.022 | 0.004 | 0.004 | 0.113 | 0.008 | 0.353 | 0.029 | 0.053 | 0.032 | 1.000 | 0.036 |
| TRUCK_TYPE_ID | 0.040 | 0.001 | 0.001 | 0.123 | 0.002 | 0.160 | 0.334 | 0.386 | 0.180 | 0.036 | 1.000 |
| TIMESTAMP | GPSNORTHING | GPSEASTING | GPSELEVATION | FUEL_RATE | STATUS | PAYLOAD | TRUCK_ID | TRUCK_TYPE_ID | SHOVEL_ID | DUMP_ID | RND | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 1648944064000 | 55334.328779 | 224524.094341 | 402.9144 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 11 | 1648944082000 | 55250.890875 | 224568.985459 | 402.3460 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 19 | 1648944098000 | 55236.506152 | 224491.232652 | 400.4378 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 21 | 1648944102000 | 55252.532868 | 224465.523704 | 398.0018 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 24 | 1648944108000 | 55288.883906 | 224411.149771 | 392.3178 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 40 | 1648944140000 | 55514.308992 | 224539.611022 | 374.6974 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 44 | 1648944148000 | 55573.410229 | 224622.415133 | 370.7186 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 47 | 1648944154000 | 55605.646336 | 224663.560834 | 366.6992 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 71 | 1648944202000 | 56164.526453 | 224993.898258 | 357.1176 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| 104 | 1648944268000 | 56634.574606 | 225308.730247 | 352.0426 | NaN | Empty | 0.0 | 0 | 0 | 0 | 0 | 0 |
| TIMESTAMP | GPSNORTHING | GPSEASTING | GPSELEVATION | FUEL_RATE | STATUS | PAYLOAD | TRUCK_ID | TRUCK_TYPE_ID | SHOVEL_ID | DUMP_ID | RND | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19288039 | 1648950190000 | 60412.696940 | 228647.729980 | 306.4488 | 202.0100 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288054 | 1648950220000 | 60700.782780 | 228465.097398 | 307.8292 | 197.8280 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288062 | 1648950236000 | 60823.435953 | 228544.015772 | 305.9210 | 196.0000 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288068 | 1648950248000 | 60910.504685 | 228612.216075 | 305.6368 | 199.3025 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288070 | 1648950252000 | 60934.985679 | 228630.394462 | 305.8804 | 201.3795 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288079 | 1648950270000 | 61079.573587 | 228724.914300 | 305.1496 | 197.8905 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288088 | 1648950288000 | 61235.910674 | 228794.566803 | 306.5706 | 197.0890 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288090 | 1648950292000 | 61239.654205 | 228814.677157 | 306.9766 | 199.4595 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288093 | 1648950298000 | 61216.359638 | 228834.084380 | 306.8548 | 205.1040 | Hauling | NaN | 32 | 3 | 4 | 4 | 0 |
| 19288129 | 1648950368000 | 61135.857382 | 228851.565018 | 308.7630 | 196.0000 | Dumping | 0.0 | 32 | 3 | 4 | 4 | 0 |
Most frequently occurring
| TIMESTAMP | GPSNORTHING | GPSEASTING | GPSELEVATION | FUEL_RATE | STATUS | PAYLOAD | TRUCK_ID | TRUCK_TYPE_ID | SHOVEL_ID | DUMP_ID | RND | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1695 | 1649589506000 | 52962.294981 | 227576.000227 | 232.6380 | NaN | NON_PRODUCTIVE | 0.000 | 7 | 4 | 2 | 1 | 0 | 3 |
| 1748 | 1649592786000 | 52605.324649 | 227660.808637 | 242.2602 | NaN | NON_PRODUCTIVE | 0.000 | 7 | 4 | 2 | 1 | 0 | 3 |
| 1781 | 1649595450000 | 52601.552504 | 227661.693957 | 245.9142 | NaN | NON_PRODUCTIVE | 0.000 | 7 | 4 | 2 | 1 | 0 | 3 |
| 0 | 1648948438000 | 58718.439945 | 228642.744231 | 101.6218 | 196.4525 | NON_PRODUCTIVE | 0.000 | 5 | 3 | 4 | 7 | 0 | 2 |
| 1 | 1648948830000 | 56454.550604 | 228973.063170 | 95.7348 | NaN | NON_PRODUCTIVE | 0.000 | 19 | 2 | 1 | 2 | 0 | 2 |
| 2 | 1648949298000 | 55205.574332 | 223465.386117 | 359.9596 | 196.4110 | NON_PRODUCTIVE | 0.000 | 12 | 3 | 3 | 5 | 0 | 2 |
| 3 | 1648953676000 | 58778.375051 | 228590.848831 | 87.8584 | 196.5755 | Empty | 0.000 | 32 | 3 | 4 | 9 | 0 | 2 |
| 4 | 1648954478000 | 56297.674071 | 228984.536348 | 87.2900 | NaN | Empty | 0.000 | 34 | 3 | 1 | 1 | 0 | 2 |
| 5 | 1648954618000 | 58768.841177 | 228586.249941 | 93.7860 | NaN | Empty | 0.000 | 20 | 3 | 4 | 9 | 0 | 2 |
| 6 | 1648959312000 | 53161.757250 | 227654.566913 | 230.5674 | NaN | Hauling | 338.741 | 7 | 4 | 2 | 11 | 0 | 2 |